Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_AW_LOAD_DIM_PARMS

`ALL_AW_LOAD_DIM_PARMS` lists the parameters in dimension load specifications.

Dimension load specifications determine how dimension members will be loaded from the dimension table into the analytic workspace.

Parameters are set for dimension load specifications by the `DBMS_AWM.SET_AWDIMLOAD_SPEC_PARAMETER` procedure.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`owner` | `varchar2(30)` |  | Owner of the source dimension in the OLAP Catalog.
`dimension_name` | `varchar2(30)` |  | Name of the source dimension in the OLAP Catalog.
`load_name` | `varchar2(60)` |  | Name of the dimension load specification.
`parm_name` | `varchar2(16)` |  | '`UNIQUE_RDBMS_KEY`' -- Whether or not the members of this dimension are unique across all levels in the source tables. '`DISPLAY_NAME'` -- Display name for the target dimension in the analytic workspace. '`PLURAL_DISPLAY_NAME'` -- Plural display name for the target dimension in the analytic workspace.
`parm_value` | `varchar2(4000)` |  | Values of `UNIQUE_RDBMS_KEY`: `NO`-- Dimension member names are not unique across levels in the RDBMS tables. The corresponding dimension member names in the analytic workspace include the level name as a prefix. (Default) `YES` -- Dimension member names are unique across levels in the RDBMS tables. The corresponding dimension member names in the analytic workspace have the same names as in the source relational dimension. Value of `DISPLAY_NAME` is the display name for the target dimension in the analytic workspace. Value of `PLURAL_DISPLAY_NAME` is the plural display name for the target dimension in the analytic workspace.